Evaluate(Object[]) Method

In This Topic

Adds the cells specified by a given criteria.

Syntax

'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As Object _
) As Object

'Usage
 
Dim instance As CalcSumIfFunction
Dim args() As Object
Dim value As Object
 
value = instance.Evaluate(args)

public override object Evaluate( 
   object[] args
)

args

The args contains 2 - 3 items: range, criteria, [sum_range].

Range is the range of cells that you want evaluated by criteria.

Criteria is the criteria in the form of a number, expression, or text that defines which cells will be added.

[Sum_range] are the actual cells to add if their corresponding cells in range match criteria.

A System.Double value that indicates the evaluate result.